package main.java.jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCDemo11 {
    public static void main(String[] args) {
        try (Connection connection = DBUtil.getConnection();){
            connection.setAutoCommit(false);
            String sql = "DELETE FROM userinfo WHERE id = 4";
            Statement statement = connection.createStatement();
            int num = statement.executeUpdate(sql);
            System.out.println(num>0?"删除成功":"删除失败");
            connection.rollback();
            System.out.println("事务回滚了");
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}
